Teaching statistics with Excel 2007 and other spreadsheets
نویسنده
چکیده
This article considers which activities in teaching statistics may be suitable candidates for the application of spreadsheets, and whether spreadsheets in general and Excel 2007 in particular are suitable for these tasks. © 2008 Elsevier B.V. All rights reserved.
منابع مشابه
Using Spreadsheets and VBA for Teaching Civil Engineering Concepts
Spreadsheets are becoming increasingly popular in solving engineering related problems. Among the strong features of spreadsheets are their instinctive cell-based structure and easy to use capabilities. Excel, for example, is a powerful spreadsheet with VBA robust programming capabilities that can be a powerful tool for teaching civil engineering concepts. Spreadsheets can do basic calculations...
متن کاملAssessing Excel VBA Suitability for Monte Carlo Simulation
Monte Carlo (MC) simulation includes a wide range of stochastic techniques used to quantitatively evaluate the behavior of complex systems or processes. Microsoft Excel spreadsheets with Visual Basic for Applications (VBA) software is, arguably, the most commonly employed general purpose tool for MC simulation. Despite the popularity of the Excel in many industries and educational institutions,...
متن کاملSpreadsheets as a Tool for Teaching Simulation
Simulation can be a difficult subject to teach, as most commercial software requires learning new approaches and time is limited, particularly in business overview courses. Spreadsheets have a distinct advantage in that most students developed a high level of expertise prior to taking management science courses. As such, they provide an ideal platform on which to learn the basics of simulation ...
متن کاملImplementing logic spreadsheets in LESS
Spreadsheets are a widespread tool for a variety of tasks, particularly in business settings. Spreadsheet users employ a form of programming that, while popular, is highly errorprone and has limited expressiveness. An important approach to augment spreadsheets is to provide logic knowledge representation and reasoning (KR&R) functionality. In this paper we present Logic Embedded in SpreadSheets...
متن کاملEnhancing Mathematical Graphical Displays in Excel through Animation
Enhancing Mathematical Graphical Displays in Excel through AnimationThe use of spreadsheets in teaching mathematics has increased significantly in recent years. One can implement mathematical algorithms, models, visualizations, and applications naturally and effectively through interactive spreadsheet constructions and creative graphical displays. This paper demonstrates techniques that enable ...
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
عنوان ژورنال:
- Computational Statistics & Data Analysis
دوره 52 شماره
صفحات -
تاریخ انتشار 2008